SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[AccountInfoUpdate]
    @Id UNIQUEIDENTIFIER ,
    @ServiceInfoId UNIQUEIDENTIFIER ,
    @Login VARBINARY(MAX) ,
    @Password VARBINARY(MAX) ,
    @Email VARBINARY(MAX) ,
    @FirstName VARBINARY(MAX) ,
    @LastName VARBINARY(MAX) ,
    @SecretQuestion VARBINARY(MAX) ,
    @SecretAnswer VARBINARY(MAX) ,
    @MobilePhone VARBINARY(MAX) ,
    @ShortId VARBINARY(MAX) ,
    @AdditionalInfo VARBINARY(MAX)
AS 
    BEGIN 
        UPDATE  AccountInfo
        SET     ServiceInfoId = @ServiceInfoId ,
                LOGIN = @LOGIN ,
                PASSWORD = @PASSWORD ,
                Email = @Email ,
                FirstName = @FirstName ,
                LastName = @LastName ,
                SecretQuestion = @SecretQuestion ,
                SecretAnswer = @SecretAnswer ,
                MobilePhone = @MobilePhone ,
                ShortId = @ShortId ,
                AdditionalInfo = @AdditionalInfo
        WHERE   Id = @Id
        
    END

GO
